Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
-
Re: How to default the parameter initial value to the latest/max date?
Hi @Job21 fyi. I have used the 'Time.Date' column. If you are using any other subject area to create this parameter ensure you have a filter on some metric in the query to fetch default val…1 -
Re: Count days function in subject area
Hi, you can use the below formula TIMESTAMPDIFF(SQL_TSI_DAY, <Task Assigned Date> ,CURRENT_DATE) Raghu1 -
Re: Average Time To Fill metric for Recruiting Subject Areas - Target: 20C
Hi LipLooi, thank you for testing this and reaching out to me. I think you might be missing something here. I created a similar report where a specific requisition has gone through 'suspended…1 -
Re: Left Outer Join in FAW-OAC
Naeem, you could do this using data sets. * Create a data set with required columns from the FAW subject area and create a project of it. * Add the second data set which could be from a different sub…1 -
Re: Terminations Report
Aaron, You can do a cross subject area report using work relationship real time and assignment event real time. The 'HR Action' and 'HR Action reason' folders in assignment event …2
